delete from NotaFiscalC

set identity_insert NotaFiscalC on 
insert into NotaFiscalC
(Codigo,
NumeroNota,
CodCliente,
NomeCliente,
Status,
CodEmp,
DataHora,
DataEmissao,
XmlNFE,
DataHoraEmissao,
DataHoraSaida,
Chave,
Protocolo,
TotalNota,
ModeloNota
)
select 
Codigo_nfc,
NroNotaFiscal_nfc,
CodigoDest_nfc,
NomeDest_nfc,
'ENVIADA',
1,
DataEmissao_nfc,
DataEmissao_nfc,
XMLNFe_nfc,
DataEmissao_nfc,
DataSaida_nfc,
NfeChave_nfc,
NfeProtocolo_nfc,
TotalNota_nfc,
'NFE'
from Dados_db..NotaFiscalC_tb d
where d.Codigo_emp = 2
and d.CodigoDest_nfc in (select Codigo from Cliente)
set identity_insert NotaFiscalC off

select * from Dados_db..NotaFiscalC_tb d





